package mypage;

import common.db.*;
import common.main.*;

public class ReviewListBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String id = (String)inputTable.get("id");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT a.SEQ, a.REG_DATE, d.PAY_KIN, a.PRICE, b.STEP, c.DELIVERY_STATE, a.ORDER_STATE ");
		queryBuffer.append("FROM MAGIC a, ORDER_STATE b, DELIVERY_STATE c, PAY_KIND d ");
		queryBuffer.append("WHERE a.ID = '"+id+"' AND a.ORDER_STATE = b.SEQ AND a.DELIVERY_STATE = c.SEQ AND a.PAY_CODE = d.SEQ ORDER BY SEQ");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}
